<html>
<head>
<title>HTML Frames Example - Content</title>
<style type="text/css">
body {
	font-family:verdana,arial,sans-serif;
	font-size:10pt;
	margin:30px;
	background-color:#ffcc00;
	}
</style>
</head>
<body>
<h1>Mark if a Book has been received</h1><br />

<form name= "addorder" action="warehouseemployeepage_action.php" method="post">


<?php
$username="bsc353_4";
$password="sonbeans";
$database="bsc353_4";

mysql_connect("clipper.encs.concordia.ca",$username,$password) or die ("Unable to connect to database");

@mysql_select_db($database) or die ("Unable to select database");
$orderquery= "Select orderNumber from Orders where status='Requested'";
$allorder=mysql_query($orderquery);
$numorder= mysql_numrows($allorder);
mysql_close();

echo"<p>Order Number: ";
echo"<select name='ordernumber'>";
echo"<option>Select One</option>";
$i=0;
while($i<$numorder)
    {
    $value=mysql_result($allorder,$i,"orderNumber");
    echo "<option>$value</option>";
    ++$i;
    }   
echo"</select></p>";

?>
<input type="submit" value="Order is ready">

</form> 


</body>
</html>